<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/5/4
 * Time: 20:05
 */

namespace app\shared\model;

class Sms extends \app\BaseModel
{

    public $allowQuery = 'id,uid,mobile,msg,use,sms_type,ctime,etime';
    private static function sql()
    {
        $sql = "CREATE TABLE `sms` (
  `id` int(10) NOT NULL COMMENT '主键',
  `uid` int(10) NOT NULL COMMENT '用户ID',
  `mobile` char(11) NOT NULL COMMENT '接收手机',
  `code` varchar(255) NOT NULL COMMENT '短信内容',
  `use` tinyint(1) NOT NULL COMMENT '使用:1=前台,2=后台',
  `sms_type` tinyint(1) NOT NULL COMMENT '类型:1=短信验证码...',
  `ctime` int(10) NOT NULL COMMENT '发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
    }
}